Advanced Financial Analysis using Excel
General Objectives:
This course is designed to
- Provide the participants with the knowledge, skills and tools necessary to analyze an entity's financial information and evaluate its financial position
- Enhance the participants' efficiency in terms of analysis using computer and making use of Excel advanced features
- Introduce the participants to financial indicators and ratios and their importance in decision making and the manner of summarizing analysis results and presenting them to the senior management using Excel
Targeted Group:
• Financial managers
• Financial analysts and consultants
• External auditors
• Internal auditors
• Managers and officials who take decisions regarding costs, investment, purchase and funding
• General managers who wish to deeply understand methods of financial analysis application
Contents:
• Concept of financial analysis and its importance
• Types of financial analysis
• Basic financial statements and their importance in decision making
• Sources of funding and utilization of resources
• Financial analysis of financial statements
- Liquidity ratios
- Indebtedness ratios
- Profitability ratios
- Operating ratios
• Analysis of cash flows and its importance
• Other methods in financial analysis
- Financial horizontal analysis and the process of its calculation using Excel spreadsheets
- Financial vertical analysis and the process of its calculation using Excel spreadsheets
- Financial ratios, their types and importance and the process of their electronic calculation
• Analysis of current assets management
• Analysis of long term financial position
• Methods and concepts of money time value
• Capital investments valuation
• Significant spreadsheets for the purposes of financial analysis using Excel
• Practical examples and cases
• Open discussion
Course Duration:
20 training hours
For more details don’t hesitate to contact the training officer:
on telephone number 17383001
or e-mail at: gizrmrmt.yzsizrm@gztrgizrmrmt.xln